How to: Assign a password to a database.
Solution:
Open the desired database in exclusive mode, select 'Security' from the 'Tools' menu and select 'Set Database Password...', then type the password in the 'Set Database Password' dialog box.
NOTE 1: A database password cannot be set if user-level security has been defined for the database and the user does not have the Administer permission to the database.
NOTE 2: If user-level security has been defined, any database restrictions based on user-level security permissions still remain in effect.
1) Close the desired database.
NOTE: In a multi-user environment, have all users close the database.
2) Select the 'File' menu and select 'Open Database...'. (The Open dialog box appears.)
the Open dialog box
3) Select the drive where the desired database is located from the 'Look in' drop-down list.
4) Select the folder that contains the database file in the 'Look in' list box. (The desired database file appears in the Look in list box.)
NOTE: If the file is in a subfolder, continue selecting folders in the 'Look in' list box until the database file is displayed.
5) Select the database file. (The file is highlighted.)
6) Select the 'Exclusive' check box.
the Exclusive check box
7) Click 'Open'. (The database opens in the exclusive mode.)
8) Select the 'Tools' menu and select 'Security'. (A submenu appears.)
9) Select 'Set Database Password...' from the submenu. (The Set Database Password dialog box appears.)
10) Type the password in the 'Password' box.
NOTE: Access passwords are case-sensitive.
11) In the 'Verify' box, type the password again to confirm it.
Setting a database password
12) Click 'OK'. (The next time the database is opened, a dialog box prompting for the password will appear.)
CAUTION 1: Keep a list of passwords and their databases in a safe place. Do not forget a database password, otherwise it cannot be recovered and the database cannot be opened.
CAUTION 2: Do not set a database password for a database that needs to be replicated. Replicated databases cannot be synchronized if passwords are defined.
